String Functions – QUOTENAME()

I am going to continue my series of very short articles or tidbits on Transaction SQL string functions. I will exploring the QUOTENAME() function today. The QUOTENAME() function takes a input of type sysname, nvarchar(128) and returns a string, nvarchar(258) with quote characters at front and end of the string. A optional string can be specified to redefine the default quote character for TSQL. The following example creates a table name in the adventure works database from two variables. [crayon-6646b5c01fdc3684560242/] [crayon-6646b5c01fdce519353549/] The default quote characters [] can be changed by … Continue reading String Functions – QUOTENAME()